Creating line and stacked column with Week Duration 15
a. Creating line and
stacked column for week duration
On field and shared axis Week
Duration column, and column
value WORDS PER DAY and Line value Completeness but change
the name only for Visual . click down
the arrow and choose Rename for this visual (completeness%)
b. To Format, Go to General X position =
764, y position =450, width = 636 height = 450
c. Legend = ON color black (000000)
font family =Cambria Math, text 12 style =markers only, Match
line color =on, circle default icon =on
d. x-axis color black,
text size 15, font family = Cambria Math, minimum category width 20 Max
= 20 Inner padding 20% concatenate labels on, Title off
e. y-axis color(605E5C) text
size 15, font family Cambria
Math and title =off
f. Gridlines on color
(B3B3B3) stoke width 1, line style =solid , show
secondary= on Align zeros= On
g. Y-Axis(Line), color (009292) text
Size 16 font family Cambria Math, Title= off
h. data Colors ,completeness
% = (009292), Default color( 99CDE7)
i. Data labels On,
color(8952BF )text
size 16, font family Cambria Math, ,show background on , background
color =white transparency 30%
j. customize series on , WORDS PER DAY color (EC8FCA) text size =16
font family Cambria
Math, show background =on, background color = white
k. shapes area On, stroke
width 0, join types Miter Line style solid
l. Tittle on ‘WORDS
PER DAY BY WEEK’ , word wrap on font color black,
background color(6DB6FF),alignment = center , text size = 17 font family =Cambria Math
m. Background = off
n. Lock aspect =off
o. Border = off
p. Tooltip = on
q. Visual header= on
for 12 week please drug and drop on add filter filed and select Last 12 weeks see on screenshot
please follow the gif
Learn more about KPIs here:
https://www.optimizesmart.com/understanding-key-performance-indicators-kpis-just-like-that/#a18